Tabela TreatmentStepsAttachment

Definicja tabeli TreatmentStepsAttachment

Name

TreatmentStepsAttachment

Code

TreatmentStepsAttachment

Comment

Tabela przechowujaca dane o zalacznikach dla etapów leczenia. Kolumna FilePath zawiera sciezki dla repozytorium doc-managament.


Lista kolumn tabeli TreatmentStepsAttachment

Name

Code

TreatmentStepsAttachmentID

TreatmentStepsAttachmentID

TreatmentStepsID

TreatmentStepsID

FileName

FileName

FilePath

FilePath

Active

Active


Kolumna TreatmentStepsAttachmentID tabeli TreatmentStepsAttachment

Definicja kolumny TreatmentStepsAttachmentID tabeli TreatmentStepsAttachment

Name

TreatmentStepsAttachmentID

Code

TreatmentStepsAttachmentID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna TreatmentStepsID tabeli TreatmentStepsAttachment

Definicja kolumny TreatmentStepsID tabeli TreatmentStepsAttachment

Name

TreatmentStepsID

Code

TreatmentStepsID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna FileName tabeli TreatmentStepsAttachment

Definicja kolumny FileName tabeli TreatmentStepsAttachment

Name

FileName

Code

FileName

Data Type

VARCHAR2(128)

Mandatory

Yes

Comment

 


Kolumna FilePath tabeli TreatmentStepsAttachment

Definicja kolumny FilePath tabeli TreatmentStepsAttachment

Name

FilePath

Code

FilePath

Data Type

VARCHAR2(255)

Mandatory

Yes

Comment

 


Kolumna Active tabeli TreatmentStepsAttachment

Definicja kolumny Active tabeli TreatmentStepsAttachment

Name

Active

Code

Active

Data Type

NUMBER(5)

Mandatory

Yes

Comment

 


Lista kluczy tabeli TreatmentStepsAttachment

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli TreatmentStepsAttachment

Definicja klucza Identifier_1 tabeli TreatmentStepsAttachment

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment